﻿CREATE TABLE [dbo].[tAppConfig]
(
	[appConfigId] INT NOT NULL CONSTRAINT[pk_tAppConfig_appConfigId] PRIMARY KEY IDENTITY(1,1),
	[name] VARCHAR(150) NOT NULL,
	[description] VARCHAR(1000) NULL,
	[valueString] VARCHAR(max) NULL,
	[valueBit] BIT NULL,
	[valueFloat] FLOAT NULL,
	[valueInt] INT NULL,
	[isActive] BIT NOT NULL CONSTRAINT [df_tAppConfig_iaActive] DEFAULT 1, 
    [isDeleted] BIT NOT NULL CONSTRAINT [df_tAppConfig_isDeleted] DEFAULT 0, 
)
